Consequeue of Failure Sewer Main Break

FME

500 m SANMN01103 flow path (highlighted in green) is intersect with the creek flow path (thinnest line). However, the intersector transformer is failed to create the intersection nodes between the two lines. The intersector transformer only create one intersection node corresponding the the SANMN01103 flow path (green dot in figure below.

COF, LOF, Risk Score

• We have calculated risk scores using LOF value from the Assess Dataset that you provided, and COF for each factor was based on literature reviews. You can find the attached images for the GIS map displaying the risk scores of 27 out of 29 sewer mains corresponding to the Assess Dataset inside the #1 DHL Lynn Vally Oct 6 2021 folder and a table containing all the COF, LOF and risk scores of the 27 sewer mains. All the calculations were done using FME.
• Two sewer mains with the id of SANMN86600 (located on Jerome Pl.) and SANMN0893 (located on WEYMOUTH DR.) did not match with the ASSET ID found in the SanMain shape file.
• I calculate COF based on the following factor:
  1. Pipe age (Year)
     1. Break key = 1 if age <10
     2. Break key = 2 if 10 <= age < 25
     3. Break key = 3 if 25 <= age < 40
     4. Break key = 4 if 40 <= age < 50
     5. Break key = 5 if age >= 50
  2. Pipe diameter (mm)
     1. Break key = 1 if pipe diameter <= 150
     2. Break key = 2 if 150 < pipe diameter <= 300
     3. Break key = 3 if 300 < pipe diameter <= 450
     4. Break key = 4 if 450 < pipe diameter < 750
     5. Break key = 5 if pipe diameter >= 750
  3. Pipe Length (m)
     1. Break key = 1 if length < 6
     2. Break key = 2 if 6<= length < 12.2
     3. Break key = 3 if 12.2 <= length < 18.3
     4. Break key = 4 if 18.3 <= length < 24.4
     5. Break key = 5 if length >= 24.4
  4. Average Depth between upstream elevation (UP_ELEV) and downstream elevation (DN_ELEV)
     1. Break key = 1 if depth <= 1.2
     2. Break key = 2 if 1.2 < depth < 3
     3. Break key = 3 if 3 <= depth < 5.5
     4. Break key = 4 if 5.5 <= depth < 7.3
     5. Break key = 5 if depth >= 7.3
  5. The shortest distance from the flow path if the sewer main was to break at the centroid to the nearest creek. The break key is based on the distance implemented for watermain break in the DNV.
     1. Break key = 1 if 500 m sewer main break flow path does not intersect with any creek flow path
     2. Break key = 3 if distance > 300
     3. Break key = 4 if 100 <= distance <= 300
     4. Break key = 5 if distance <100
• All the factors are weighted equally. The final COF score = 0.2(sum of all the break key values) and the risk score is equal to COF LOF. The LOF values are from the Assess Databases provided by DNV.